Bentley Map V8i (SELECTseries 10) Help

Importing an ODBC Data Source

The process for importing an ODBC source is similar to that for CSV with slight changes to the format of the VRT file. The ODBC VRT file is shown below.

<OGRVRTDataSource>
   <OGRVRTLayer name="town_aus">
       <SrcDataSource>ODBC:town_aus</SrcDataSource>
        <SrcLayer>City</SrcLayer> 
       <GeometryType>wkbPoint</GeometryType>
       <LayerSRS>WGS84</LayerSRS>
       <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
   </OGRVRTLayer> 
</OGRVRTDataSource>

First, set up an ODBC data source to the Microsoft Access data file. In this case the ODBC data source is called town_aus and is described in the SrcDataSource tag above. A new entry describing the layer name is also added. This points to the table in Microsoft Access; in our example called city. All other tags remain the same.